<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="error_Page.jsp" %>
<% 
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:sis");
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("SELECT * FROM Result WHERE SName='Faisal'");
while(rs.next()){
out.println("<table>");
out.println("<tr>");
String id=rs.getString(1);
out.println("<td>"+id+"<td>");
String Name=rs.getString(2);
out.println("<td>"+Name+"<td>");
String Subject=rs.getString(3);
out.println("<td>"+Subject+"<td>");
}
}
catch(Exception e){
}
 %>
<html>
<head>
<title>Testing JSP</title>
</head>
<body>

</body>
</html>
